Skip to main content
Feedback

Adding a database (legacy) Write profile

note

The Database (Legacy) Profile and Database (Legacy) connector are no longer actively maintained. We encourage you to migrate to the updated Database V2 connector.

For Write profiles, the Data Elements tab is where you define the SQL statement(s) to insert, update, or delete records. Use the Data Elements tab to select the data for the database Write for mapping data. Select input fields based on requirements. Database Write profiles use input fields as the destination profile in a map.

Procedure

  1. Create a database (legacy) profile.

  2. On the Options tab, set the Execution Type field to Write.

  3. On the Data Elements tab click the Statement node.

  4. Do one of the following:

    • Set the Type field to Standard Insert/Update/Date and enter or cut and paste your SQL statement in the SQL Script field or the code editor. To open the code editor, click Edit.

    • Set the Type field to Stored Procedure Write and in the Stored Procedure field, enter the stored procedure's name.

    • Set the Type field to Dynamic Insert, Dynamic Update or Dynamic Delete and enter a table name.

  5. If you set the Type field to one of the Dynamic options, you can click Import to launch the Import Wizard to automatically generate the statement and input fields.

  6. On the Data Elements tab, add fields as needed.

    Only Dynamic Delete profiles do not contain fields.

    1. Click the drop-down arrow icon next to Fields and choose Add Field.

    2. Select the field in the left pane and in the right pane, change the field’s name.

    3. Turn on the Mandatory and/or the Enforce Unique check boxes, as needed.

    4. Expand the Data Format Options section and select a data type.

    5. Repeat these steps as needed to add more fields.

      note

      Each question mark defined in the SQL statement serves as a placeholder and must bind positionally to the field listed in the profile.

  7. Dynamic Update and Dynamic Delete profiles can contain conditions. Add conditions as needed.

    1. Click the drop-down arrow icon next to Conditions and choose Add Condition.

    2. Select the condition in the left pane and in the right pane, change the condition’s name.

    3. Select an operator.

    4. Expand the Data Format Options section and select a data type.

    5. Repeat these steps as needed to add more conditions.

  8. Click Save.

On this Page